Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 173659 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 19.9 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 6 |
| Unsupported | 3 |
OrdenDeCompraID has a high cardinality: 1472 distinct values | High cardinality |
FechaTransaccion has a high cardinality: 2155 distinct values | High cardinality |
NombreProducto has a high cardinality: 227 distinct values | High cardinality |
TransaccionProductoID is highly correlated with InvoiceID and 1 other fields | High correlation |
ProductoID is highly correlated with Cantidad and 1 other fields | High correlation |
InvoiceID is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad is highly correlated with ProductoID and 3 other fields | High correlation |
ValorTotal_Con_PrecioUnitario is highly correlated with Cantidad and 2 other fields | High correlation |
ValorTotal_Con_PrecioRecomendado is highly correlated with Cantidad and 2 other fields | High correlation |
Año is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad_abs is highly correlated with ProductoID and 3 other fields | High correlation |
TransaccionProductoID is highly correlated with InvoiceID and 1 other fields | High correlation |
TipoTransaccionID is highly correlated with Cantidad and 3 other fields | High correlation |
InvoiceID is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad is highly correlated with TipoTransaccionID and 3 other fields | High correlation |
ValorTotal_Con_PrecioUnitario is highly correlated with TipoTransaccionID and 3 other fields | High correlation |
ValorTotal_Con_PrecioRecomendado is highly correlated with TipoTransaccionID and 3 other fields | High correlation |
Año is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad_abs is highly correlated with TipoTransaccionID and 3 other fields | High correlation |
TransaccionProductoID is highly correlated with InvoiceID and 1 other fields | High correlation |
InvoiceID is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad is highly correlated with Cantidad_abs | High correlation |
ValorTotal_Con_PrecioUnitario is highly correlated with ValorTotal_Con_PrecioRecomendado and 1 other fields | High correlation |
ValorTotal_Con_PrecioRecomendado is highly correlated with ValorTotal_Con_PrecioUnitario and 1 other fields | High correlation |
Año is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad_abs is highly correlated with Cantidad and 2 other fields | High correlation |
TipoTransaccionID is highly correlated with ProveedorID | High correlation |
ProveedorID is highly correlated with TipoTransaccionID | High correlation |
TransaccionProductoID is highly correlated with InvoiceID and 1 other fields | High correlation |
TipoTransaccionID is highly correlated with InvoiceID and 5 other fields | High correlation |
InvoiceID is highly correlated with TransaccionProductoID and 7 other fields | High correlation |
ProveedorID is highly correlated with TipoTransaccionID and 5 other fields | High correlation |
Cantidad is highly correlated with TipoTransaccionID and 5 other fields | High correlation |
ValorTotal_Con_PrecioUnitario is highly correlated with TipoTransaccionID and 5 other fields | High correlation |
ValorTotal_Con_PrecioRecomendado is highly correlated with TipoTransaccionID and 5 other fields | High correlation |
Año is highly correlated with TransaccionProductoID and 1 other fields | High correlation |
Cantidad_abs is highly correlated with TipoTransaccionID and 5 other fields | High correlation |
TransaccionProductoID is uniformly distributed | Uniform |
TransaccionProductoID has unique values | Unique |
FechaTransaccionAjustada is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PrecioUnitario is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PrecioRecomendado is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ClienteID has 6072 (3.5%) zeros | Zeros |
InvoiceID has 6072 (3.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-06-17 21:21:23.505828 |
|---|---|
| Analysis finished | 2024-06-17 21:21:43.765827 |
| Duration | 20.26 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
TransaccionProductoID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 173659 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 212512.8321 |
| Minimum | 89146 |
|---|---|
| Maximum | 336251 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 678.5 KiB |
Quantile statistics
| Minimum | 89146 |
|---|---|
| 5-th percentile | 101474.9 |
| Q1 | 150707.5 |
| median | 212419 |
| Q3 | 274254.5 |
| 95-th percentile | 323926.1 |
| Maximum | 336251 |
| Range | 247105 |
| Interquartile range (IQR) | 123547 |
Descriptive statistics
| Standard deviation | 71345.47913 |
|---|---|
| Coefficient of variation (CV) | 0.335723158 |
| Kurtosis | -1.199871973 |
| Mean | 212512.8321 |
| Median Absolute Deviation (MAD) | 61764 |
| Skewness | 0.003294818852 |
| Sum | 3.690476592 × 1010 |
| Variance | 5090177393 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 221111 | 1 | < 0.1% |
| 111704 | 1 | < 0.1% |
| 279685 | 1 | < 0.1% |
| 192618 | 1 | < 0.1% |
| 319310 | 1 | < 0.1% |
| 109812 | 1 | < 0.1% |
| 159838 | 1 | < 0.1% |
| 189996 | 1 | < 0.1% |
| 254469 | 1 | < 0.1% |
| 291210 | 1 | < 0.1% |
| Other values (173649) | 173649 |
| Value | Count | Frequency (%) |
| 89146 | 1 | |
| 89147 | 1 | |
| 89148 | 1 | |
| 89149 | 1 | |
| 89150 | 1 | |
| 89151 | 1 | |
| 89153 | 1 | |
| 89154 | 1 | |
| 89181 | 1 | |
| 89183 | 1 |
| Value | Count | Frequency (%) |
| 336251 | 1 | |
| 336250 | 1 | |
| 336249 | 1 | |
| 336248 | 1 | |
| 336247 | 1 | |
| 336245 | 1 | |
| 336244 | 1 | |
| 336243 | 1 | |
| 336242 | 1 | |
| 336241 | 1 |
| Distinct | 227 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.6737745 |
| Minimum | 1 |
|---|---|
| Maximum | 227 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 678.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 56 |
| median | 110 |
| Q3 | 166 |
| 95-th percentile | 210 |
| Maximum | 227 |
| Range | 226 |
| Interquartile range (IQR) | 110 |
Descriptive statistics
| Standard deviation | 63.52289916 |
|---|---|
| Coefficient of variation (CV) | 0.5739652367 |
| Kurtosis | -1.192928697 |
| Mean | 110.6737745 |
| Median Absolute Deviation (MAD) | 55 |
| Skewness | 0.01168125345 |
| Sum | 19219497 |
| Variance | 4035.158718 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 80 | 1274 | 0.7% |
| 95 | 1254 | 0.7% |
| 184 | 1150 | 0.7% |
| 86 | 1110 | 0.6% |
| 193 | 1109 | 0.6% |
| 77 | 1101 | 0.6% |
| 204 | 1096 | 0.6% |
| 78 | 1089 | 0.6% |
| 98 | 1087 | 0.6% |
| 214 | 841 | 0.5% |
| Other values (217) | 162548 |
| Value | Count | Frequency (%) |
| 1 | 767 | |
| 2 | 790 | |
| 3 | 763 | |
| 4 | 785 | |
| 5 | 751 | |
| 6 | 758 | |
| 7 | 760 | |
| 8 | 751 | |
| 9 | 773 | |
| 10 | 782 |
| Value | Count | Frequency (%) |
| 227 | 118 | 0.1% |
| 226 | 151 | 0.1% |
| 225 | 127 | 0.1% |
| 224 | 118 | 0.1% |
| 223 | 117 | 0.1% |
| 222 | 149 | 0.1% |
| 221 | 131 | 0.1% |
| 220 | 135 | 0.1% |
| 219 | 794 | |
| 218 | 749 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 10 | |
|---|---|
| 11 | 6035 |
| 12 | 37 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 347318 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10 |
|---|---|
| 2nd row | 10 |
| 3rd row | 10 |
| 4th row | 10 |
| 5th row | 10 |
Common Values
| Value | Count | Frequency (%) |
| 10 | 167587 | |
| 11 | 6035 | 3.5% |
| 12 | 37 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 10 | 167587 | |
| 11 | 6035 | 3.5% |
| 12 | 37 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 179694 | |
| 0 | 167587 | |
| 2 | 37 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 347318 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 179694 | |
| 0 | 167587 | |
| 2 | 37 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 347318 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 179694 | |
| 0 | 167587 | |
| 2 | 37 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 347318 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 179694 | |
| 0 | 167587 | |
| 2 | 37 | < 0.1% |
| Distinct | 664 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 517.2418821 |
| Minimum | 0 |
|---|---|
| Maximum | 1061 |
| Zeros | 6072 |
| Zeros (%) | 3.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 145 |
| median | 511 |
| Q3 | 877 |
| 95-th percentile | 1010 |
| Maximum | 1061 |
| Range | 1061 |
| Interquartile range (IQR) | 732 |
Descriptive statistics
| Standard deviation | 353.4912165 |
|---|---|
| Coefficient of variation (CV) | 0.6834156875 |
| Kurtosis | -1.451732608 |
| Mean | 517.2418821 |
| Median Absolute Deviation (MAD) | 366 |
| Skewness | -0.02666969492 |
| Sum | 89823708 |
| Variance | 124956.0401 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6072 | 3.5% |
| 980 | 352 | 0.2% |
| 810 | 341 | 0.2% |
| 185 | 337 | 0.2% |
| 558 | 336 | 0.2% |
| 149 | 335 | 0.2% |
| 954 | 334 | 0.2% |
| 804 | 333 | 0.2% |
| 953 | 331 | 0.2% |
| 118 | 329 | 0.2% |
| Other values (654) | 164559 |
| Value | Count | Frequency (%) |
| 0 | 6072 | |
| 1 | 295 | 0.2% |
| 2 | 283 | 0.2% |
| 3 | 302 | 0.2% |
| 4 | 209 | 0.1% |
| 5 | 286 | 0.2% |
| 6 | 255 | 0.1% |
| 7 | 266 | 0.2% |
| 8 | 198 | 0.1% |
| 9 | 275 | 0.2% |
| Value | Count | Frequency (%) |
| 1061 | 29 | < 0.1% |
| 1060 | 15 | < 0.1% |
| 1059 | 30 | < 0.1% |
| 1058 | 50 | |
| 1057 | 55 | |
| 1056 | 45 | |
| 1055 | 78 | |
| 1054 | 84 | |
| 1053 | 71 | |
| 1052 | 92 |
InvoiceID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 51831 |
|---|---|
| Distinct (%) | 29.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42972.01054 |
| Minimum | 0 |
|---|---|
| Maximum | 70510 |
| Zeros | 6072 |
| Zeros (%) | 3.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 19484 |
| Q1 | 30149 |
| median | 43565 |
| Q3 | 56988 |
| 95-th percentile | 67835 |
| Maximum | 70510 |
| Range | 70510 |
| Interquartile range (IQR) | 26839 |
Descriptive statistics
| Standard deviation | 16823.71872 |
|---|---|
| Coefficient of variation (CV) | 0.3915041094 |
| Kurtosis | -0.3824902 |
| Mean | 42972.01054 |
| Median Absolute Deviation (MAD) | 13420 |
| Skewness | -0.3662493315 |
| Sum | 7462476379 |
| Variance | 283037511.5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6072 | 3.5% |
| 30531 | 5 | < 0.1% |
| 19791 | 5 | < 0.1% |
| 68698 | 5 | < 0.1% |
| 31099 | 5 | < 0.1% |
| 53188 | 5 | < 0.1% |
| 35760 | 5 | < 0.1% |
| 31047 | 5 | < 0.1% |
| 51800 | 5 | < 0.1% |
| 57229 | 5 | < 0.1% |
| Other values (51821) | 167542 |
| Value | Count | Frequency (%) |
| 0 | 6072 | |
| 18681 | 1 | < 0.1% |
| 18682 | 1 | < 0.1% |
| 18683 | 1 | < 0.1% |
| 18684 | 3 | < 0.1% |
| 18685 | 3 | < 0.1% |
| 18686 | 5 | < 0.1% |
| 18687 | 4 | < 0.1% |
| 18688 | 4 | < 0.1% |
| 18689 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 70510 | 5 | |
| 70509 | 5 | |
| 70508 | 5 | |
| 70507 | 3 | |
| 70506 | 4 | |
| 70505 | 3 | |
| 70504 | 3 | |
| 70503 | 5 | |
| 70502 | 2 | < 0.1% |
| 70501 | 3 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 4.0 | 4103 |
|---|---|
| 7.0 | 1922 |
| 1.0 | 10 |
Length
| Max length | 3 |
|---|---|
| Median length | 0 |
| Mean length | 0.104256042 |
| Min length | 0 |
Characters and Unicode
| Total characters | 18105 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 167624 | ||
| 4.0 | 4103 | 2.4% |
| 7.0 | 1922 | 1.1% |
| 1.0 | 10 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 4.0 | 4103 | |
| 7.0 | 1922 | |
| 1.0 | 10 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 6035 | |
| 0 | 6035 | |
| 4 | 4103 | |
| 7 | 1922 | 10.6% |
| 1 | 10 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12070 | |
| Other Punctuation | 6035 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6035 | |
| 4 | 4103 | |
| 7 | 1922 | 15.9% |
| 1 | 10 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 6035 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18105 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 6035 | |
| 0 | 6035 | |
| 4 | 4103 | |
| 7 | 1922 | 10.6% |
| 1 | 10 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18105 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 6035 | |
| 0 | 6035 | |
| 4 | 4103 | |
| 7 | 1922 | 10.6% |
| 1 | 10 | 0.1% |
| Distinct | 1472 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1292.0 | 6 |
|---|---|
| 1299.0 | 6 |
| 1301.0 | 6 |
| 1307.0 | 6 |
| Other values (1467) | 6011 |
Length
| Max length | 6 |
|---|---|
| Median length | 0 |
| Mean length | 0.1994656194 |
| Min length | 0 |
Characters and Unicode
| Total characters | 34639 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 76 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 167624 | ||
| 1292.0 | 6 | < 0.1% |
| 1299.0 | 6 | < 0.1% |
| 1301.0 | 6 | < 0.1% |
| 1307.0 | 6 | < 0.1% |
| 1311.0 | 6 | < 0.1% |
| 1313.0 | 6 | < 0.1% |
| 1315.0 | 6 | < 0.1% |
| 1327.0 | 6 | < 0.1% |
| 1333.0 | 6 | < 0.1% |
| Other values (1462) | 5981 | 3.4% |
Length
| Value | Count | Frequency (%) |
| 1292.0 | 6 | 0.1% |
| 1089.0 | 6 | 0.1% |
| 860.0 | 6 | 0.1% |
| 1877.0 | 6 | 0.1% |
| 1930.0 | 6 | 0.1% |
| 1708.0 | 6 | 0.1% |
| 787.0 | 6 | 0.1% |
| 1022.0 | 6 | 0.1% |
| 1331.0 | 6 | 0.1% |
| 1630.0 | 6 | 0.1% |
| Other values (1461) | 5975 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7981 | |
| . | 6035 | |
| 1 | 5786 | |
| 6 | 2024 | 5.8% |
| 9 | 2016 | 5.8% |
| 8 | 2000 | 5.8% |
| 2 | 1954 | 5.6% |
| 7 | 1954 | 5.6% |
| 4 | 1652 | 4.8% |
| 3 | 1620 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 28604 | |
| Other Punctuation | 6035 | 17.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7981 | |
| 1 | 5786 | |
| 6 | 2024 | 7.1% |
| 9 | 2016 | 7.0% |
| 8 | 2000 | 7.0% |
| 2 | 1954 | 6.8% |
| 7 | 1954 | 6.8% |
| 4 | 1652 | 5.8% |
| 3 | 1620 | 5.7% |
| 5 | 1617 | 5.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 6035 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 34639 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7981 | |
| . | 6035 | |
| 1 | 5786 | |
| 6 | 2024 | 5.8% |
| 9 | 2016 | 5.8% |
| 8 | 2000 | 5.8% |
| 2 | 1954 | 5.6% |
| 7 | 1954 | 5.6% |
| 4 | 1652 | 4.8% |
| 3 | 1620 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 34639 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7981 | |
| . | 6035 | |
| 1 | 5786 | |
| 6 | 2024 | 5.8% |
| 9 | 2016 | 5.8% |
| 8 | 2000 | 5.8% |
| 2 | 1954 | 5.6% |
| 7 | 1954 | 5.6% |
| 4 | 1652 | 4.8% |
| 3 | 1620 | 4.7% |
| Distinct | 2155 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 2015-01-21 12:00:00.0000000 | 256 |
|---|---|
| 2016-05-04 12:00:00.0000000 | 254 |
| 2016-03-23 12:00:00.0000000 | 249 |
| 2015-11-03 12:00:00.0000000 | 247 |
| 2015-04-14 12:00:00.0000000 | 247 |
| Other values (2150) |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 21.07998434 |
| Min length | 11 |
Characters and Unicode
| Total characters | 3660729 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Apr 30,2015 |
|---|---|
| 2nd row | Apr 13,2015 |
| 3rd row | May 13,2016 |
| 4th row | Apr 02,2015 |
| 5th row | Apr 01,2015 |
Common Values
| Value | Count | Frequency (%) |
| 2015-01-21 12:00:00.0000000 | 256 | 0.1% |
| 2016-05-04 12:00:00.0000000 | 254 | 0.1% |
| 2016-03-23 12:00:00.0000000 | 249 | 0.1% |
| 2015-11-03 12:00:00.0000000 | 247 | 0.1% |
| 2015-04-14 12:00:00.0000000 | 247 | 0.1% |
| 2015-10-06 12:00:00.0000000 | 246 | 0.1% |
| 2015-10-19 12:00:00.0000000 | 246 | 0.1% |
| 2015-11-24 12:00:00.0000000 | 245 | 0.1% |
| 2016-05-19 12:00:00.0000000 | 241 | 0.1% |
| 2015-02-27 12:00:00.0000000 | 241 | 0.1% |
| Other values (2145) | 171187 |
Length
| Value | Count | Frequency (%) |
| 12:00:00.0000000 | 105572 | |
| may | 6952 | 2.0% |
| apr | 6923 | 2.0% |
| jan | 6714 | 1.9% |
| mar | 6450 | 1.9% |
| feb | 5761 | 1.7% |
| jul | 5105 | 1.5% |
| oct | 4726 | 1.4% |
| jun | 4649 | 1.3% |
| dec | 4601 | 1.3% |
| Other values (856) | 189865 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1542681 | |
| 1 | 397130 | 10.8% |
| 2 | 371414 | 10.1% |
| - | 218810 | 6.0% |
| : | 218810 | 6.0% |
| 173659 | 4.7% | |
| . | 109405 | 3.0% |
| 5 | 103606 | 2.8% |
| 4 | 97684 | 2.7% |
| , | 64254 | 1.8% |
| Other values (27) | 363276 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2683029 | |
| Other Punctuation | 392469 | 10.7% |
| Dash Punctuation | 218810 | 6.0% |
| Space Separator | 173659 | 4.7% |
| Lowercase Letter | 128508 | 3.5% |
| Uppercase Letter | 64254 | 1.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 20116 | |
| e | 14719 | |
| u | 13717 | |
| r | 13373 | |
| n | 11363 | |
| p | 11280 | |
| c | 9327 | |
| y | 6952 | 5.4% |
| b | 5761 | 4.5% |
| l | 5105 | 4.0% |
| Other values (4) | 16795 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1542681 | |
| 1 | 397130 | 14.8% |
| 2 | 371414 | 13.8% |
| 5 | 103606 | 3.9% |
| 4 | 97684 | 3.6% |
| 6 | 55130 | 2.1% |
| 3 | 38051 | 1.4% |
| 7 | 28216 | 1.1% |
| 9 | 25214 | 0.9% |
| 8 | 23903 | 0.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 16468 | |
| M | 13402 | |
| A | 10886 | |
| F | 5761 | 9.0% |
| O | 4726 | 7.4% |
| D | 4601 | 7.2% |
| S | 4357 | 6.8% |
| N | 4053 | 6.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 218810 | |
| . | 109405 | |
| , | 64254 | 16.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 218810 |
Space Separator
| Value | Count | Frequency (%) |
| 173659 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3467967 | |
| Latin | 192762 | 5.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 20116 | 10.4% |
| J | 16468 | 8.5% |
| e | 14719 | 7.6% |
| u | 13717 | 7.1% |
| M | 13402 | 7.0% |
| r | 13373 | 6.9% |
| n | 11363 | 5.9% |
| p | 11280 | 5.9% |
| A | 10886 | 5.6% |
| c | 9327 | 4.8% |
| Other values (12) | 58111 |
Common
| Value | Count | Frequency (%) |
| 0 | 1542681 | |
| 1 | 397130 | 11.5% |
| 2 | 371414 | 10.7% |
| - | 218810 | 6.3% |
| : | 218810 | 6.3% |
| 173659 | 5.0% | |
| . | 109405 | 3.2% |
| 5 | 103606 | 3.0% |
| 4 | 97684 | 2.8% |
| , | 64254 | 1.9% |
| Other values (5) | 170514 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3660729 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1542681 | |
| 1 | 397130 | 10.8% |
| 2 | 371414 | 10.1% |
| - | 218810 | 6.0% |
| : | 218810 | 6.0% |
| 173659 | 4.7% | |
| . | 109405 | 3.0% |
| 5 | 103606 | 2.8% |
| 4 | 97684 | 2.7% |
| , | 64254 | 1.8% |
| Other values (27) | 363276 | 9.9% |
| Distinct | 3383 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 716.7980813 |
| Minimum | -360 |
|---|---|
| Maximum | 67368 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 167606 |
| Negative (%) | 96.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -360 |
|---|---|
| 5-th percentile | -150 |
| Q1 | -60 |
| median | -9 |
| Q3 | -5 |
| 95-th percentile | -1 |
| Maximum | 67368 |
| Range | 67728 |
| Interquartile range (IQR) | 55 |
Descriptive statistics
| Standard deviation | 4718.727053 |
|---|---|
| Coefficient of variation (CV) | 6.583063176 |
| Kurtosis | 61.82103881 |
| Mean | 716.7980813 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 7.409037017 |
| Sum | 124478438 |
| Variance | 22266385.01 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -10 | 11555 | 6.7% |
| -5 | 9456 | 5.4% |
| -8 | 9426 | 5.4% |
| -2 | 9388 | 5.4% |
| -7 | 9333 | 5.4% |
| -1 | 9299 | 5.4% |
| -3 | 9184 | 5.3% |
| -6 | 9152 | 5.3% |
| -4 | 9073 | 5.2% |
| -9 | 9051 | 5.2% |
| Other values (3373) | 78742 |
| Value | Count | Frequency (%) |
| -360 | 143 | 0.1% |
| -324 | 159 | 0.1% |
| -288 | 141 | 0.1% |
| -260 | 95 | 0.1% |
| -252 | 154 | 0.1% |
| -250 | 878 | |
| -240 | 794 | |
| -234 | 73 | < 0.1% |
| -225 | 884 | |
| -216 | 908 |
| Value | Count | Frequency (%) |
| 67368 | 1 | |
| 67272 | 1 | |
| 67200 | 1 | |
| 66840 | 1 | |
| 66744 | 1 | |
| 66696 | 1 | |
| 66480 | 1 | |
| 66288 | 1 | |
| 65904 | 1 | |
| 65760 | 1 |
| Distinct | 227 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| "The Gu" red shirt XML tag t-shirt (White) M | 1274 |
|---|---|
| "The Gu" red shirt XML tag t-shirt (Black) XL | 1254 |
| Shipping carton (Brown) 305x305x305mm | 1150 |
| "The Gu" red shirt XML tag t-shirt (White) 5XL | 1110 |
| Black and orange glass with care despatch tape 48mmx75m | 1109 |
| Other values (222) |
Length
| Max length | 85 |
|---|---|
| Median length | 63 |
| Mean length | 41.89720084 |
| Min length | 20 |
Characters and Unicode
| Total characters | 7275826 |
|---|---|
| Distinct characters | 72 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Halloween skull mask (Gray) L |
|---|---|
| 2nd row | Halloween skull mask (Gray) L |
| 3rd row | Halloween skull mask (Gray) L |
| 4th row | Halloween skull mask (Gray) L |
| 5th row | Halloween skull mask (Gray) L |
Common Values
| Value | Count | Frequency (%) |
| "The Gu" red shirt XML tag t-shirt (White) M | 1274 | 0.7% |
| "The Gu" red shirt XML tag t-shirt (Black) XL | 1254 | 0.7% |
| Shipping carton (Brown) 305x305x305mm | 1150 | 0.7% |
| "The Gu" red shirt XML tag t-shirt (White) 5XL | 1110 | 0.6% |
| Black and orange glass with care despatch tape 48mmx75m | 1109 | 0.6% |
| "The Gu" red shirt XML tag t-shirt (White) XXS | 1101 | 0.6% |
| Tape dispenser (Red) | 1096 | 0.6% |
| "The Gu" red shirt XML tag t-shirt (White) XS | 1089 | 0.6% |
| "The Gu" red shirt XML tag t-shirt (Black) 4XL | 1087 | 0.6% |
| Air cushion film 200mmx200mm 325m | 841 | 0.5% |
| Other values (217) | 162548 |
Length
| Value | Count | Frequency (%) |
| black | 50705 | 3.9% |
| 43584 | 3.4% | |
| white | 34345 | 2.7% |
| mug | 34265 | 2.6% |
| joke | 32698 | 2.5% |
| red | 30338 | 2.3% |
| the | 27022 | 2.1% |
| gu | 22368 | 1.7% |
| shirt | 22368 | 1.7% |
| xml | 22368 | 1.7% |
| Other values (279) | 975583 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1128028 | 15.5% | |
| e | 603207 | 8.3% |
| a | 371593 | 5.1% |
| r | 356443 | 4.9% |
| t | 338855 | 4.7% |
| i | 323671 | 4.4% |
| o | 285872 | 3.9% |
| l | 262299 | 3.6% |
| s | 233027 | 3.2% |
| m | 215519 | 3.0% |
| Other values (62) | 3157312 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4788417 | |
| Space Separator | 1128028 | 15.5% |
| Uppercase Letter | 605649 | 8.3% |
| Decimal Number | 323713 | 4.4% |
| Close Punctuation | 141413 | 1.9% |
| Open Punctuation | 141413 | 1.9% |
| Dash Punctuation | 72284 | 1.0% |
| Other Punctuation | 70299 | 1.0% |
| Math Symbol | 4610 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 603207 | 12.6% |
| a | 371593 | 7.8% |
| r | 356443 | 7.4% |
| t | 338855 | 7.1% |
| i | 323671 | 6.8% |
| o | 285872 | 6.0% |
| l | 262299 | 5.5% |
| s | 233027 | 4.9% |
| m | 215519 | 4.5% |
| h | 214532 | 4.5% |
| Other values (16) | 1583399 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 111310 | |
| L | 68869 | |
| X | 61472 | |
| S | 46488 | |
| D | 42767 | 7.1% |
| G | 37945 | 6.3% |
| M | 33740 | 5.6% |
| A | 33512 | 5.5% |
| W | 32841 | 5.4% |
| T | 31177 | 5.1% |
| Other values (12) | 105528 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 79618 | |
| 1 | 56059 | |
| 2 | 47409 | |
| 5 | 46209 | |
| 3 | 26749 | 8.3% |
| 4 | 21400 | 6.6% |
| 7 | 15854 | 4.9% |
| 8 | 15703 | 4.9% |
| 9 | 10800 | 3.3% |
| 6 | 3912 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| " | 44736 | |
| / | 13942 | 19.8% |
| , | 3142 | 4.5% |
| . | 2297 | 3.3% |
| ' | 1583 | 2.3% |
| ? | 1550 | 2.2% |
| : | 1539 | 2.2% |
| … | 1510 | 2.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 3084 | |
| = | 1526 |
Space Separator
| Value | Count | Frequency (%) |
| 1128028 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 141413 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 141413 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 72284 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5394066 | |
| Common | 1881760 | 25.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 603207 | 11.2% |
| a | 371593 | 6.9% |
| r | 356443 | 6.6% |
| t | 338855 | 6.3% |
| i | 323671 | 6.0% |
| o | 285872 | 5.3% |
| l | 262299 | 4.9% |
| s | 233027 | 4.3% |
| m | 215519 | 4.0% |
| h | 214532 | 4.0% |
| Other values (38) | 2189048 |
Common
| Value | Count | Frequency (%) |
| 1128028 | ||
| ) | 141413 | 7.5% |
| ( | 141413 | 7.5% |
| 0 | 79618 | 4.2% |
| - | 72284 | 3.8% |
| 1 | 56059 | 3.0% |
| 2 | 47409 | 2.5% |
| 5 | 46209 | 2.5% |
| " | 44736 | 2.4% |
| 3 | 26749 | 1.4% |
| Other values (14) | 97842 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7274316 | |
| Punctuation | 1510 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1128028 | 15.5% | |
| e | 603207 | 8.3% |
| a | 371593 | 5.1% |
| r | 356443 | 4.9% |
| t | 338855 | 4.7% |
| i | 323671 | 4.4% |
| o | 285872 | 3.9% |
| l | 262299 | 3.6% |
| s | 233027 | 3.2% |
| m | 215519 | 3.0% |
| Other values (61) | 3155802 |
Punctuation
| Value | Count | Frequency (%) |
| … | 1510 |
ValorTotal_Con_PrecioUnitario
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 3826 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12390.09444 |
| Minimum | 0 |
|---|---|
| Maximum | 1038400 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 100 |
| median | 250 |
| Q3 | 1050 |
| 95-th percentile | 5600 |
| Maximum | 1038400 |
| Range | 1038400 |
| Interquartile range (IQR) | 950 |
Descriptive statistics
| Standard deviation | 75509.20657 |
|---|---|
| Coefficient of variation (CV) | 6.094320501 |
| Kurtosis | 65.01696815 |
| Mean | 12390.09444 |
| Median Absolute Deviation (MAD) | 190 |
| Skewness | 7.702427882 |
| Sum | 2151651411 |
| Variance | 5701640277 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 864 | 3615 | 2.1% |
| 91 | 3443 | 2.0% |
| 288 | 3437 | 2.0% |
| 13 | 3364 | 1.9% |
| 26 | 3328 | 1.9% |
| 104 | 3326 | 1.9% |
| 39 | 3285 | 1.9% |
| 65 | 3269 | 1.9% |
| 96 | 3243 | 1.9% |
| 78 | 3240 | 1.9% |
| Other values (3816) | 140109 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 156 | 0.1% |
| 13 | 3364 | |
| 16 | 222 | 0.1% |
| 20 | 152 | 0.1% |
| 25 | 1379 | |
| 26 | 3328 |
| Value | Count | Frequency (%) |
| 1038400 | 1 | |
| 1035840 | 1 | |
| 1035200 | 1 | |
| 1031680 | 1 | |
| 1031040 | 2 | |
| 1030720 | 1 | |
| 1027520 | 1 | |
| 1022080 | 1 | |
| 1021440 | 1 | |
| 1020800 | 1 |
ValorTotal_Con_PrecioRecomendado
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 3918 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18512.78642 |
| Minimum | 0 |
|---|---|
| Maximum | 1557600 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 148 |
| median | 375 |
| Q3 | 1548 |
| 95-th percentile | 8350 |
| Maximum | 1557600 |
| Range | 1557600 |
| Interquartile range (IQR) | 1400 |
Descriptive statistics
| Standard deviation | 113183.9247 |
|---|---|
| Coefficient of variation (CV) | 6.113824364 |
| Kurtosis | 65.22266078 |
| Mean | 18512.78642 |
| Median Absolute Deviation (MAD) | 285 |
| Skewness | 7.717590752 |
| Sum | 3214911977 |
| Variance | 1.28106008 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1296 | 3509 | 2.0% |
| 144 | 3492 | 2.0% |
| 133 | 3443 | 2.0% |
| 432 | 3426 | 2.0% |
| 288 | 3367 | 1.9% |
| 19 | 3364 | 1.9% |
| 38 | 3328 | 1.9% |
| 152 | 3326 | 1.9% |
| 57 | 3285 | 1.9% |
| 95 | 3269 | 1.9% |
| Other values (3908) | 139850 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 15 | 84 | < 0.1% |
| 19 | 3364 | |
| 20 | 72 | < 0.1% |
| 24 | 222 | 0.1% |
| 25 | 137 | 0.1% |
| 30 | 85 | < 0.1% |
| Value | Count | Frequency (%) |
| 1557600 | 1 | |
| 1553760 | 1 | |
| 1552800 | 1 | |
| 1547520 | 1 | |
| 1546560 | 2 | |
| 1546080 | 1 | |
| 1541280 | 1 | |
| 1533120 | 1 | |
| 1532160 | 1 | |
| 1531200 | 1 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 2015 | |
|---|---|
| 2014 | |
| 2016 | |
| 2013 | 298 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 694636 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2016 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2015 | 74451 | |
| 2014 | 68386 | |
| 2016 | 30524 | |
| 2013 | 298 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2015 | 74451 | |
| 2014 | 68386 | |
| 2016 | 30524 | |
| 2013 | 298 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 173659 | |
| 0 | 173659 | |
| 1 | 173659 | |
| 5 | 74451 | |
| 4 | 68386 | 9.8% |
| 6 | 30524 | 4.4% |
| 3 | 298 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 694636 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 173659 | |
| 0 | 173659 | |
| 1 | 173659 | |
| 5 | 74451 | |
| 4 | 68386 | 9.8% |
| 6 | 30524 | 4.4% |
| 3 | 298 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 694636 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 173659 | |
| 0 | 173659 | |
| 1 | 173659 | |
| 5 | 74451 | |
| 4 | 68386 | 9.8% |
| 6 | 30524 | 4.4% |
| 3 | 298 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 694636 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 173659 | |
| 0 | 173659 | |
| 1 | 173659 | |
| 5 | 74451 | |
| 4 | 68386 | 9.8% |
| 6 | 30524 | 4.4% |
| 3 | 298 | < 0.1% |
| Distinct | 3341 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 792.353912 |
| Minimum | 0 |
|---|---|
| Maximum | 67368 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 10 |
| Q3 | 70 |
| 95-th percentile | 225 |
| Maximum | 67368 |
| Range | 67368 |
| Interquartile range (IQR) | 65 |
Descriptive statistics
| Standard deviation | 4706.629273 |
|---|---|
| Coefficient of variation (CV) | 5.940059363 |
| Kurtosis | 62.01186818 |
| Mean | 792.353912 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.419282739 |
| Sum | 137599388 |
| Variance | 22152359.12 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 11559 | 6.7% |
| 5 | 9456 | 5.4% |
| 8 | 9426 | 5.4% |
| 2 | 9391 | 5.4% |
| 7 | 9333 | 5.4% |
| 1 | 9301 | 5.4% |
| 3 | 9189 | 5.3% |
| 6 | 9152 | 5.3% |
| 4 | 9077 | 5.2% |
| 9 | 9051 | 5.2% |
| Other values (3331) | 78724 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 9301 | |
| 2 | 9391 | |
| 3 | 9189 | |
| 4 | 9077 | |
| 5 | 9456 | |
| 6 | 9152 | |
| 7 | 9333 | |
| 8 | 9426 | |
| 9 | 9051 |
| Value | Count | Frequency (%) |
| 67368 | 1 | |
| 67272 | 1 | |
| 67200 | 1 | |
| 66840 | 1 | |
| 66744 | 1 | |
| 66696 | 1 | |
| 66480 | 1 | |
| 66288 | 1 | |
| 65904 | 1 | |
| 65760 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| TransaccionProductoID | ProductoID | TipoTransaccionID | ClienteID | InvoiceID | ProveedorID | OrdenDeCompraID | FechaTransaccion | Cantidad | FechaTransaccionAjustada | NombreProducto | PrecioUnitario | PrecioRecomendado | ValorTotal_Con_PrecioUnitario | ValorTotal_Con_PrecioRecomendado | Año | Cantidad_abs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 221111 | 148 | 10 | 13.0 | 46305.0 | Apr 30,2015 | -96.0 | 2015-04-30 | Halloween skull mask (Gray) L | 18 | 27 | 1728.0 | 2592.0 | 2015 | 96.0 | ||
| 1 | 215349 | 148 | 10 | 562.0 | 45092.0 | Apr 13,2015 | -96.0 | 2015-04-13 | Halloween skull mask (Gray) L | 18 | 27 | 1728.0 | 2592.0 | 2015 | 96.0 | ||
| 2 | 330727 | 148 | 10 | 1048.0 | 69359.0 | May 13,2016 | -24.0 | 2016-05-13 | Halloween skull mask (Gray) L | 18 | 27 | 432.0 | 648.0 | 2016 | 24.0 | ||
| 3 | 212115 | 148 | 10 | 826.0 | 44413.0 | Apr 02,2015 | -12.0 | 2015-04-02 | Halloween skull mask (Gray) L | 18 | 27 | 216.0 | 324.0 | 2015 | 12.0 | ||
| 4 | 211641 | 148 | 10 | 841.0 | 44310.0 | Apr 01,2015 | -72.0 | 2015-04-01 | Halloween skull mask (Gray) L | 18 | 27 | 1296.0 | 1944.0 | 2015 | 72.0 | ||
| 5 | 103218 | 148 | 10 | 952.0 | 21631.0 | Feb 22,2014 | -72.0 | 2014-02-22 | Halloween skull mask (Gray) L | 18 | 27 | 1296.0 | 1944.0 | 2014 | 72.0 | ||
| 6 | 231596 | 148 | 10 | 591.0 | 48500.0 | Jun 04,2015 | -84.0 | 2015-06-04 | Halloween skull mask (Gray) L | 18 | 27 | 1512.0 | 2268.0 | 2015 | 84.0 | ||
| 7 | 202123 | 148 | 10 | 528.0 | 42324.0 | Feb 26,2015 | -12.0 | 2015-02-26 | Halloween skull mask (Gray) L | 18 | 27 | 216.0 | 324.0 | 2015 | 12.0 | ||
| 8 | 99371 | 148 | 10 | 461.0 | 20817.0 | Feb 07,2014 | -108.0 | 2014-02-07 | Halloween skull mask (Gray) L | 18 | 27 | 1944.0 | 2916.0 | 2014 | 108.0 | ||
| 9 | 214833 | 148 | 10 | 127.0 | 44986.0 | Apr 10,2015 | -108.0 | 2015-04-10 | Halloween skull mask (Gray) L | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 |
Last rows
| TransaccionProductoID | ProductoID | TipoTransaccionID | ClienteID | InvoiceID | ProveedorID | OrdenDeCompraID | FechaTransaccion | Cantidad | FechaTransaccionAjustada | NombreProducto | PrecioUnitario | PrecioRecomendado | ValorTotal_Con_PrecioUnitario | ValorTotal_Con_PrecioRecomendado | Año | Cantidad_abs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173649 | 253439 | 89 | 10 | 157.0 | 53094.0 | 2015-08-17 12:00:00.0000000 | -108.0 | 2015-08-17 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 | ||
| 173650 | 280884 | 89 | 10 | 85.0 | 58853.0 | 2015-11-19 12:00:00.0000000 | -108.0 | 2015-11-19 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 | ||
| 173651 | 333369 | 89 | 10 | 402.0 | 69897.0 | 2016-05-21 12:00:00.0000000 | -108.0 | 2016-05-21 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2016 | 108.0 | ||
| 173652 | 234969 | 89 | 10 | 439.0 | 49195.0 | 2015-06-16 12:00:00.0000000 | -108.0 | 2015-06-16 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 | ||
| 173653 | 181883 | 89 | 10 | 949.0 | 38078.0 | 2014-12-16 12:00:00.0000000 | -108.0 | 2014-12-16 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2014 | 108.0 | ||
| 173654 | 116140 | 89 | 10 | 73.0 | 24308.0 | 2014-04-16 12:00:00.0000000 | -108.0 | 2014-04-16 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2014 | 108.0 | ||
| 173655 | 264095 | 89 | 10 | 845.0 | 55349.0 | 2015-09-23 12:00:00.0000000 | -108.0 | 2015-09-23 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 | ||
| 173656 | 107529 | 89 | 10 | 542.0 | 22518.0 | 2014-03-12 12:00:00.0000000 | -108.0 | 2014-03-12 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2014 | 108.0 | ||
| 173657 | 123617 | 89 | 10 | 945.0 | 25882.0 | 2014-05-13 12:00:00.0000000 | -108.0 | 2014-05-13 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2014 | 108.0 | ||
| 173658 | 290446 | 89 | 10 | 459.0 | 60854.0 | 2015-12-24 12:00:00.0000000 | -108.0 | 2015-12-24 | "The Gu" red shirt XML tag t-shirt (Black) 3XS | 18 | 27 | 1944.0 | 2916.0 | 2015 | 108.0 |